package com.ruoyi.buss.grid.sq.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.core.annotation.Excel;
import com.ruoyi.common.core.web.domain.BaseEntity;

import java.math.BigDecimal;

/**
 * 网格社区按社区维度统计对象 DATA_WG_WGSQ_SQ
 * 
 * @author sxy
 * @date 2021-07-16
 */
public class DataWgWgsqSq extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
    private String id;

    /** 所属社区 */
    @Excel(name = "所属社区")
    private String sssq;

    /** 户数 */
    @Excel(name = "户数")
    private String hs;

    /** 存款户数 */
    @Excel(name = "存款户数")
    private String ckhs;

    /** 存款金额 */
    @Excel(name = "存款金额")
    private String ckye;

    /** 贷款户数 */
    @Excel(name = "贷款户数")
    private String dkhs;

    /** 贷款余额 */
    @Excel(name = "贷款余额")
    private String dkye;

    /** etc户数 */
    @Excel(name = "etc户数")
    private String etchs;

    /** 信用卡户数 */
    @Excel(name = "信用卡户数")
    private String xykhs;

    /** 省级微信户数 */
    @Excel(name = "省级微信户数")
    private String sjwxhs;

    /** 社保卡户数 */
    @Excel(name = "社保卡户数")
    private String sbkhs;

    /** 有效贷款人数 */
    @Excel(name = "有效贷款人数")
    private String yxdkrs;

    /** 人数 */
    @Excel(name = "人数")
    private String rs;

    /** 电子银行个数 */
    @Excel(name = "电子银行个数")
    private String dzyhgs;

    /** 家庭有产品户数   家庭产品数>0 */
    @Excel(name = "家庭有产品户数   家庭产品数>0")
    private String productFamilyHs;

    /** 产品覆盖面   有产品户数 /总户数 */
    @Excel(name = "产品覆盖面   有产品户数 /总户数")
    private String productCoverage;

    /** 有效家庭户数      家庭产品数>=3  且 （有效存款或贷款有其一）  有效存款：日均>=5000 */
    @Excel(name = "有效家庭户数      家庭产品数>=3  且 ", readConverterExp = "有=效存款或贷款有其一")
    private String vaildFamilyHs;

    /** 有效家庭覆盖面   有效家庭户数/总户数 */
    @Excel(name = "有效家庭覆盖面   有效家庭户数/总户数")
    private String familyCoverage;

    /** $column.columnComment */
    @Excel(name = "有效家庭覆盖面   有效家庭户数/总户数")
    private String orgId;

    /** $column.columnComment */
    @Excel(name = "有效家庭覆盖面   有效家庭户数/总户数")
    private String managerId;

    /** 全部入住率--用于导入汇总时使用 */
    @Excel(name = "全部入住率--用于导入汇总时使用")
    private String rzlcoount;

    /** 家庭信息覆盖面--用于导入汇总时使用 */
    @Excel(name = "家庭信息覆盖面--用于导入汇总时使用")
    private String familyfgm;

    /** 小区入住率 */
    @Excel(name = "小区入住率")
    private String rzl;

    /** 乡镇居民占比 */
    @Excel(name = "乡镇居民占比")
    private String xzjmzb;

    /** 个体工商户占比 */
    @Excel(name = "个体工商户占比")
    private String gtgshzb;

    /** 公职人员在 */
    @Excel(name = "公职人员占比")
    private String gzryzb;

    /** $column.columnComment */
    @Excel(name = "数据日期")
    private String sjrq;

    /** 预授信金额 */
    @Excel(name = "预授信金额")
    private String amountYsh;

    /** 预授信人数 */
    @Excel(name = "预授信人数")
    private String ifysx;

    /** 签约人数 */
    @Excel(name = "签约人数")
    private String qyZjhm;

    /** 授信金额 */
    @Excel(name = "授信金额")
    private String sxje;

    /** 授信签约率  （存在有效贷款合)）户数  / 总户数      (小区) */
    @Excel(name = "授信签约率  ", readConverterExp = "存=在有效贷款合)")
    private String familyQyCoverage;

    /** 小区有效授信数 */
    @Excel(name = "小区有效授信数")
    private String sfyxdkAll;

    private BigDecimal qly;
    /**
     * 有效家庭覆盖面 有效家庭户数/总户数
     */
    private double vaildCoverage;

    private int qyS;

    private int ifysxs;

    private BigDecimal pjck;

    private BigDecimal pjdk;

    private String sxqyl;

    private int sssqs;

    private  String userId;

    public String getUserId() {
        return userId;
    }

    public void setUserId(String userId) {
        this.userId = userId;
    }

    public BigDecimal getQly() {
        return qly;
    }

    public void setQly(BigDecimal qly) {
        this.qly = qly;
    }

    public double getVaildCoverage() {
        return vaildCoverage;
    }

    public void setVaildCoverage(double vaildCoverage) {
        this.vaildCoverage = vaildCoverage;
    }

    public int getQyS() {
        return qyS;
    }

    public void setQyS(int qyS) {
        this.qyS = qyS;
    }

    public int getIfysxs() {
        return ifysxs;
    }

    public void setIfysxs(int ifysxs) {
        this.ifysxs = ifysxs;
    }

    public BigDecimal getPjck() {
        return pjck;
    }

    public void setPjck(BigDecimal pjck) {
        this.pjck = pjck;
    }

    public BigDecimal getPjdk() {
        return pjdk;
    }

    public void setPjdk(BigDecimal pjdk) {
        this.pjdk = pjdk;
    }

    public String getSxqyl() {
        return sxqyl;
    }

    public void setSxqyl(String sxqyl) {
        this.sxqyl = sxqyl;
    }

    public int getSssqs() {
        return sssqs;
    }

    public void setSssqs(int sssqs) {
        this.sssqs = sssqs;
    }

    public void setId(String id)
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }
    public void setSssq(String sssq) 
    {
        this.sssq = sssq;
    }

    public String getSssq() 
    {
        return sssq;
    }
    public void setHs(String hs) 
    {
        this.hs = hs;
    }

    public String getHs() 
    {
        return hs;
    }
    public void setCkhs(String ckhs) 
    {
        this.ckhs = ckhs;
    }

    public String getCkhs() 
    {
        return ckhs;
    }
    public void setCkye(String ckye) 
    {
        this.ckye = ckye;
    }

    public String getCkye() 
    {
        return ckye;
    }
    public void setDkhs(String dkhs) 
    {
        this.dkhs = dkhs;
    }

    public String getDkhs() 
    {
        return dkhs;
    }
    public void setDkye(String dkye) 
    {
        this.dkye = dkye;
    }

    public String getDkye() 
    {
        return dkye;
    }
    public void setEtchs(String etchs) 
    {
        this.etchs = etchs;
    }

    public String getEtchs() 
    {
        return etchs;
    }
    public void setXykhs(String xykhs) 
    {
        this.xykhs = xykhs;
    }

    public String getXykhs() 
    {
        return xykhs;
    }
    public void setSjwxhs(String sjwxhs) 
    {
        this.sjwxhs = sjwxhs;
    }

    public String getSjwxhs() 
    {
        return sjwxhs;
    }
    public void setSbkhs(String sbkhs) 
    {
        this.sbkhs = sbkhs;
    }

    public String getSbkhs() 
    {
        return sbkhs;
    }
    public void setYxdkrs(String yxdkrs) 
    {
        this.yxdkrs = yxdkrs;
    }

    public String getYxdkrs() 
    {
        return yxdkrs;
    }
    public void setRs(String rs) 
    {
        this.rs = rs;
    }

    public String getRs() 
    {
        return rs;
    }
    public void setDzyhgs(String dzyhgs) 
    {
        this.dzyhgs = dzyhgs;
    }

    public String getDzyhgs() 
    {
        return dzyhgs;
    }
    public void setProductFamilyHs(String productFamilyHs) 
    {
        this.productFamilyHs = productFamilyHs;
    }

    public String getProductFamilyHs() 
    {
        return productFamilyHs;
    }
    public void setProductCoverage(String productCoverage) 
    {
        this.productCoverage = productCoverage;
    }

    public String getProductCoverage() 
    {
        return productCoverage;
    }
    public void setVaildFamilyHs(String vaildFamilyHs) 
    {
        this.vaildFamilyHs = vaildFamilyHs;
    }

    public String getVaildFamilyHs() 
    {
        return vaildFamilyHs;
    }
    public void setFamilyCoverage(String familyCoverage) 
    {
        this.familyCoverage = familyCoverage;
    }

    public String getFamilyCoverage() 
    {
        return familyCoverage;
    }
    public void setOrgId(String orgId) 
    {
        this.orgId = orgId;
    }

    public String getOrgId() 
    {
        return orgId;
    }
    public void setManagerId(String managerId) 
    {
        this.managerId = managerId;
    }

    public String getManagerId() 
    {
        return managerId;
    }
    public void setRzlcoount(String rzlcoount) 
    {
        this.rzlcoount = rzlcoount;
    }

    public String getRzlcoount() 
    {
        return rzlcoount;
    }
    public void setFamilyfgm(String familyfgm) 
    {
        this.familyfgm = familyfgm;
    }

    public String getFamilyfgm() 
    {
        return familyfgm;
    }
    public void setRzl(String rzl) 
    {
        this.rzl = rzl;
    }

    public String getRzl() 
    {
        return rzl;
    }
    public void setXzjmzb(String xzjmzb) 
    {
        this.xzjmzb = xzjmzb;
    }

    public String getXzjmzb() 
    {
        return xzjmzb;
    }
    public void setGtgshzb(String gtgshzb) 
    {
        this.gtgshzb = gtgshzb;
    }

    public String getGtgshzb() 
    {
        return gtgshzb;
    }
    public void setGzryzb(String gzryzb) 
    {
        this.gzryzb = gzryzb;
    }

    public String getGzryzb() 
    {
        return gzryzb;
    }
    public void setSjrq(String sjrq) 
    {
        this.sjrq = sjrq;
    }

    public String getSjrq() 
    {
        return sjrq;
    }
    public void setAmountYsh(String amountYsh) 
    {
        this.amountYsh = amountYsh;
    }

    public String getAmountYsh() 
    {
        return amountYsh;
    }
    public void setIfysx(String ifysx) 
    {
        this.ifysx = ifysx;
    }

    public String getIfysx() 
    {
        return ifysx;
    }
    public void setQyZjhm(String qyZjhm) 
    {
        this.qyZjhm = qyZjhm;
    }

    public String getQyZjhm() 
    {
        return qyZjhm;
    }
    public void setSxje(String sxje) 
    {
        this.sxje = sxje;
    }

    public String getSxje() 
    {
        return sxje;
    }
    public void setFamilyQyCoverage(String familyQyCoverage) 
    {
        this.familyQyCoverage = familyQyCoverage;
    }

    public String getFamilyQyCoverage() 
    {
        return familyQyCoverage;
    }
    public void setSfyxdkAll(String sfyxdkAll) 
    {
        this.sfyxdkAll = sfyxdkAll;
    }

    public String getSfyxdkAll() 
    {
        return sfyxdkAll;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("sssq", getSssq())
            .append("hs", getHs())
            .append("ckhs", getCkhs())
            .append("ckye", getCkye())
            .append("dkhs", getDkhs())
            .append("dkye", getDkye())
            .append("etchs", getEtchs())
            .append("xykhs", getXykhs())
            .append("sjwxhs", getSjwxhs())
            .append("sbkhs", getSbkhs())
            .append("yxdkrs", getYxdkrs())
            .append("rs", getRs())
            .append("dzyhgs", getDzyhgs())
            .append("productFamilyHs", getProductFamilyHs())
            .append("productCoverage", getProductCoverage())
            .append("vaildFamilyHs", getVaildFamilyHs())
            .append("familyCoverage", getFamilyCoverage())
            .append("orgId", getOrgId())
            .append("managerId", getManagerId())
            .append("rzlcoount", getRzlcoount())
            .append("familyfgm", getFamilyfgm())
            .append("rzl", getRzl())
            .append("xzjmzb", getXzjmzb())
            .append("gtgshzb", getGtgshzb())
            .append("gzryzb", getGzryzb())
            .append("sjrq", getSjrq())
            .append("amountYsh", getAmountYsh())
            .append("ifysx", getIfysx())
            .append("qyZjhm", getQyZjhm())
            .append("sxje", getSxje())
            .append("familyQyCoverage", getFamilyQyCoverage())
            .append("sfyxdkAll", getSfyxdkAll())
            .toString();
    }
}
